


-- Project: SQL Songs Data
-- Description:
	-- This is a SQL program that has data for the 200 top songs and artists, which has more data about it. 
	-- This data had 6 columns, which includes columns for the Artist, songTitle, Album, Years, wherePeak, and longChart.
	-- This program has a lot of data nd requires the peak and chart for each song too.
	-- Also, we had to create indexes for the artist and years, which also related to the characters each column has too.
	-- The keywords used is the LIKE and the % wildcard for the querys outputted based on the data.
-- Jamila Kandawala
-- Date: 11/14/2024




create database songHits; -- This is creating a database called songHits, which will have one table inside of it.

use songHits; -- This is the name of the database, which is with the use command, so it everything below will be inputted into this database.

-- This is creating a table in the database called songData, which will consists of 6 main columns.
create table songData(
	id int primary key auto_increment, -- This will make a primary key, which will be made auto-increment that means it has no value.
	Artist varchar(50), -- This is the Artist field, which will have 50 as the maximum number of characters.
	songTitle varchar(70), -- This is the songTitle field, which will have 70 as the maximum number of characters.
	Album varchar(70), -- This is the Album field, which will have 70 as the maximum number of characters.
	Years YEAR, -- This is the year field, which will have aformat and a data type, which is called YEAR, so it is already a data type made.
	wherePeak varchar(5), -- This is the wherePeak field, which will have 5 as the maximum number of characters.
	longChart varchar(20) -- This is the longChart field, which will have 20 as the maximum number of characters.
);


-- I am creating an index for the artist column, so in the other table in will say MUL under the KEY column.
create index idx_Artist on songData(Artist); 

-- I am creating an index for the Years column, so in the other table in will say MUL under the KEY column.
create index idx_Years on songData(Years); 

-- I am describing the table called songData, which is important because it shows how the columns will be created and the data will be inputted into each column.
describe songData; 

-- This is showing that all the data that will be put in the format below will be put into the songData table.
insert into songData 
(Artist, songTitle, Album, Years, wherePeak, longChart) -- This is the format of all the data, so it aligns and is easy to understand.
-- This is the values for the song data, which will be in the format above.
values 
-- This is the data of the songs and they are in the format of Artist, songTitle, Album, Years, wherePeak, longChart.
('Aretha Franklin', 'Respect', 'I Never Loved a Man the Way I Love You', '1967', '2', '10 Weeks'),
('Public Enemy', 'Fight the Power', 'Fear of a Black Planet', '1989', '29', '5 Weeks'),
('Sam Cooke', 'A Change Is Gonna Come', 'Aint That Good News', '1964', '31', '14 Weeks'),
('Bob Dylan', 'Like a Rolling Stone', 'Highway 61 Revisited', '1965', '2', '12 Weeks'),
('Nirvana', 'Smells Like Teen Spirit', 'Nevermind', '1991', '6', '25 Weeks'),
('Marvin Gaye', 'Whats Going On', 'Whats Going On', '1971', '2', '5 Weeks'),
('The Beatles', 'Strawberry Fields Forever', 'Penny Lane', '1967', '8', '11 Weeks'),
('Missy Elliott', 'Get Ur Freak On', 'Miss E...So Addictive', '2001', '7', '3 Weeks'),
('Fleetwood Mac', 'Dreams', 'Rumours', '1977', '1', '1 Week'),
('Outkast', 'Hey Ya!', 'Speakerboxxx/The Love Below', '2003', '1', '9 Weeks'),
('The Beach Boys', 'God Only Knows', 'Pet Sounds', '1966', '39', '25 Weeks'),
('Stevie Wonder', 'Superstition', 'Talking Book', '1972', '1', '15 Weeks'),
('The Rolling Stones', 'Gimme Shelter', 'Let It Bleed', '1969', '1', '44 Weeks'),
('The Kinks', 'Waterloo Sunset', 'Something Else', '1967', '2', '14 Weeks'),
('The Beatles', 'I Want to Hold Your Hand', 'Meet the Beatles!', '1963', '1', '15 Weeks'),
('Beyoncé feat. Jay-Z', 'Crazy in Love', 'Dangerously in Love', '2003', '1', '8 Weeks'),
('Queen', 'Bohemian Rhapsody', 'A Night at the Opera', '1975', '9', '9 Weeks'),
('Prince and the Revolution', 'Purple Rain', 'Purple Rain', '1984', '1', '167 Weeks'),
('John Lennon', 'Imagine', 'Imagine', '1971', '3', '47 Weeks'),
('Robyn', 'Dancing on My Own', 'Body Talk Pt.1', '2010', '93', '2 Weeks'),
('Billie Holiday', 'Strange Fruit', 'Classic Albums Vol. 1', '1939', '16', '2 Weeks'),
('The Ronettes', 'Be My Baby', 'Tedesco and Pitman', '1963', '2', '4 Weeks'),
('David Bowie', 'Heroes', 'Heroes', '1977', '24', '19 Weeks'),
('The Beatles', 'A Day in the Life', 'Sgt. Peppers Lonely Hearts Club Band', '1967', '1', '148 Weeks'),
('Kanye West feat. Pusha T', 'Runaway', 'My Beautiful Dark Twisted Fantasy', '2010', '12', '2 Weeks'),
('Joni Mitchell', 'A Case of You', 'Blue', '1971', '93', '3 Weeks'),
('Bruce Springsteen', 'Born to Run', 'Born to Run', '1975', '23', '8 Weeks'),
('Talking Heads', 'Once in a Lifetime', 'Remain in Light', '1980', '91', '14 Weeks'),
('Dr. Dre feat. Snoop Doggy Dogg', 'Nuthin but a G Thang', 'The Chronic', '1992', '2', '16 Weeks'),
('Lorde', 'Royals', 'Pure Heroine', '2011', '1', '9 Weeks'),
('The Rolling Stones', '(I Cant Get No) Satisfaction', 'Out of Our Heads', '1965', '1', '14 Weeks'),
('Notorious B.I.G.', 'Juicy', 'Ready to Die', '1994', '27', '2 Weeks'),
('Chuck Berry', 'Johnny B. Goode', 'Chuck Berry', '1958', '8', '15 Weeks'),
('James Brown', 'Papas Got a Brand New Bag', 'Papas Got a Brand New Bag', '1966', '8', '8 Weeks'),
('Little Richard', 'Tutti-Frutti', 'History Records - American Edition 7', '1955', '17', '22 Weeks'),
('The White Stripes', 'Seven Nation Army', 'Elephant', '2003', '1', '3 Weeks'),
('Prince and the Revolution', 'When Doves Cry', 'Purple Rain', '1984', '1', '5 Weeks'),
('Otis Redding', '(Sittin On) the Dock of the Bay', 'The Dock of the Bay', '1967', '1', '4 Weeks'),
('Outkast', 'B.O.B.', 'Stankonia', '2000', '69', '2 Weeks'),
('The Jimi Hendrix Experience', 'All Along the Watchtower', 'Electric Ladyland', '1968', '20', '11 Weeks'),
('Joy Division', 'Love Will Tear Us Apart', 'Love Will Tear Us Apart', '1980', '13', '10 Weeks'),
('Bob Marley and the Wailers', 'Redemption Song', 'Uprising', '1980', '41', '860 Weeks'),
('The Temptations', 'My Girl', 'The Temptations Sing Smokey', '1965', '1', '6 Weeks'),
('Michael Jackson', 'Billie Jean', 'Thriller', '1982', '1', '7 Weeks'),
('Kendrick Lamar', 'Alright', 'To Pimp a Butterfly', '2015', '81', '14 Weeks'),
('M.I.A.', 'Paper Planes', 'Kala', '2008', '4', '20 Weeks'),
('Elton John', 'Tiny Dancer', 'Madman Across the Water', '1972', '41', '14 Weeks'),
('Radiohead', 'Idioteque', 'Kid A', '2000', '1', '74 Weeks'),
('Lauryn Hill', 'Doo Wop (That Thing)', 'The Miseducation of Lauryn Hill', '1998', '1', '2 Weeks'),
('Daddy Yankee', 'Gasolina', 'Barrio Fino (Nice Hood)', '2010', '32', '24 Weeks'),
('Dionne Warwick', 'Walk on By', 'Make Way for Dionne Warwick', '1964', '6', '14 Weeks'),
('Donna Summer', 'I Feel Love', 'I Remember Yesterday', '1977', '6', '23 Weeks'),
('The Beach Boys', 'Good Vibrations', 'Smiley Smile', '1966', '1', '1 Week'),
('Smokey Robinson and the Miracles', 'The Tracks of My Tears', 'Going to a Go-Go', '1965', '16', '14 Weeks'),
('Madonna', 'Like a Prayer', 'Like a Prayer', '1989', '38', '3 Weeks'),
('Missy Elliott', 'Work It', 'Under Construction', '2000', '2', '26 Weeks'),
('Sly and the Family Stone', 'Family Affair', 'Theres a Riot Goin On', '1971', '1', '15 Weeks'),
('The Band', 'The Weight', 'Music from Big Pink', '1968', '63', '7 Weeks'),
('Grandmaster Flash and the Furious Five', 'The Message', 'The Message', '1982', '62', '9 Weeks'),
('Kate Bush', 'Running Up That Hill', 'Hounds of Love', '1985', '30', '10 Weeks'),
('Led Zeppelin', 'Stairway to Heaven', 'Led Zep IV', '1971', '2', '283 Weeks'),
('U2', 'One', 'Achtung Baby', '1992', '10', '4 Weeks'),
('Dolly Parton', 'Jolene', 'Jolene', '1974', '60', '23 Weeks'),
('Ramones', 'Blitzkrieg Bop', 'Ramones', '1976', '111', '1 Week'),
('Earth Wind and Fire', 'September', 'The Best of Earth Wind & Fire Vol. 1', '1978', '8', '13 Weeks'),
('Simon and Garfunkel', 'Bridge Over Troubled Water', 'Bridge Over Troubled Water', '1970', '1', '85 Weeks'),
('Bob Dylan', 'Tangled Up in Blue', 'Blood on the Tracks', '1975', '31', '11 Weeks'),
('Chic', 'Good Times', 'Risqué', '1979', '1', '6 Weeks'),
('Taylor Swift', 'All Too Well', 'Red', '2012', '80', '1 Week'),
('Elvis Presley', 'Suspicious Minds', 'From Elvis in Memphis', '1969', '1', '1 Week'),
('Tracy Chapman', 'Fast Car', 'Tracy Chapman', '1988', '6', '1 Week'),
('The Beatles', 'Yesterday', 'Help!', '1965', '8', '11 Weeks'),
('Beyoncé', 'Formation', 'Lemonade', '2016', '11', '14 Weeks'),
('Leonard Cohen', 'Hallelujah', 'Various Positions', '1984', '59', '3 Weeks'),
('Pulp', 'Common People', 'Different Class', '1996', '2', '14 Weeks'),
('Johnny Cash', 'I Walk the Line', 'Johnny Cash with His Hot and Blue Guitar!', '1956', '17', '43 Weeks'),
('The Modern Lovers', 'Roadrunner', 'The Modern Lovers', '1976', '77', '3 Weeks'),
('The Four Tops', 'Reach Out (Ill Be There)', 'Reach Out', '1967', '1', '52 Weeks'),
('Amy Winehouse', 'Back to Black', 'Back to Black', '2006', '9', '166 Weeks'),
('Ray Charles', 'Whatd I Say', 'Whatd I Say', '1957', '6', '21 Weeks'),
('The Velvet Underground', 'Im Waiting for the Man', 'The Velvet Underground & Nico', '1967', '170', '5 Weeks'),
('Adele', 'Rolling in the Deep', '21', '2011', '1', '65 Weeks'),
('Bob Dylan', 'Desolation Row', 'Highway 61 Revisited', '1965', '83', '4 Weeks'),
('Al Green', 'Lets Stay Together', 'Lets Stay Together', '1971', '1', '16 Weeks'),
('Prince', 'Kiss', 'Parade', '1986', '1', '18 Weeks'),
('The Rolling Stones', 'Tumbling Dice', 'Exile on Main St', '1972', '7', '8 Weeks'),
('LCD Soundsystem', 'All My Friends', 'Sound of Silver', '2007', '41', '2 Weeks'),
('Guns N Roses', 'Sweet Child O Mine', 'Appetite for Destruction', '1987', '1', '2 Weeks'),
('The Beatles', 'Hey Jude', 'Revolution', '1968', '1', '9 Weeks'),
('Aretha Franklin', '(You Make Me Feel Like) A Natural Woman', 'Lady Soul', '1967', '8', '10 Weeks'),
('UGK feat. Outkast', 'Intl Players Anthem (I Choose You)', 'Underground Kingz', '2007', '70', '10 Weeks'),
('Little Richard', 'Good Golly Miss Molly', 'Little Richard', '1958', '2', '9 Weeks'),
('Kelly Clarkson', 'Since U Been Gone', 'Breakaway', '2004', '2', '7 Weeks'),
('Whitney Houston', 'I Will Always Love You', 'The Bodyguard: Original Soundtrack Album', '1992', '1', '14 Weeks'),
('Oasis', 'Wonderwall', '(Whats the Story) Morning Glory?', '1995', '8', '20 Weeks'),
('Jay-Z', '99 Problems', 'The Black Album', '2003', '30', '20 Weeks'),
('Patti Smith', 'Gloria', 'Horses', '1975', '71', '17 Weeks'),
('The Beatles', 'In My Life', 'Rubber Soul', '1965', '23', '14 Weeks'),
('Bee Gees', 'Stayin Alive', 'Saturday Night Fever', '1977', '1', '4 Weeks'),
('Bob Dylan', 'Blowin in the Wind', 'Freewheelin', '1963', '2', '5 Weeks'),
('Yeah Yeah Yeahs', 'Maps', 'Fever to Tell', '2003', '87', '4 Weeks'),
('Chuck Berry', 'Maybelline', 'Wee Wee Hours', '1955', '5', '1 Week'),
('Alanis Morissette', 'You Oughta Know', 'Jagged Little Pill', '1995', '4', '20 Weeks'),
('The Jackson 5', 'I Want You Back', 'Diana Ross Presents The Jackson 5', '1969', '1', '4 Weeks'),
('David Bowie', 'Life on Mars?', 'Hunky Dory', '1971', '3', '13 Weeks'),
('The Rolling Stones', 'Sympathy for the Devil', 'Beggars Banquet', '1968', '1', '14 Weeks'),
('Wu-Tang Clan', 'C.R.E.A.M.', 'Enter the Wu-Tang (36 Chambers)', '1994', '60', '1 Year'),
('The Cure', 'Just Like Heaven', 'Kiss Me Kiss Me Kiss Me', '1987', '40', '1 Week'),
('Sly and the Family Stone', 'Everyday People', 'Stand!', '1968', '1', '4 Weeks'),
('The Beatles', 'Something', 'Abbey Road', '1969', '1', '2 Weeks'),
('Bruce Springsteen', 'Thunder Road', 'Born to Run', '1975', '111', '11 Weeks'),
('R.E.M.', 'Losing My Religion', 'Out of Time', '1991', '4', '21 Weeks'),
('Stevie Wonder', 'Higher Ground', 'Innervisions', '1973', '4', '25 Weeks'),
('Britney Spears', 'Toxic', 'In the Zone', '2003', '9', '14 Weeks'),
('Etta James', 'At Last', 'At Last!', '1960', '47', '17 Weeks'),
('Rob Base and DJ E-Z Rock', 'It Takes Two', 'It Takes Two', '1988', '36', '16 Weeks'),
('Aretha Franklin', 'I Say a Little Prayer', 'Aretha Now', '1968', '10', '12 Weeks'),
('Radiohead', 'Creep', 'Pablo Honey', '1992', '34', '20 Weeks'),
('Marvin Gaye', 'I Heard It Through the Grapevine', 'In the Groove', '1968', '1', '15 Weeks'),
('X-Ray Spex', 'Oh Bondage! Up Yours!', 'Live at the Roxy Club', '1977', '75', '2 Weeks'),
('The Beatles', 'Let It Be', 'Let It Be', '1970', '1', '2 Weeks'),
('The Impressions', 'People Get Ready', 'People Get Ready', '1965', '14', '14 Weeks'),
('Talking Heads', 'This Must Be the Place (Naive Melody)', 'Speaking in Tongues', '1983', '62', '8 Weeks'),
('Buddy Holly', 'Thatll Be the Day', 'My Greatest Songs', '1957', '1', '12 Weeks'),
('Sex Pistols', 'Anarchy in the U.K.', 'Never Mind the Bollocks Heres the Sex Pistols', '1977', '38', '4 Weeks'),
('George Michael', 'Freedom! 90', 'Listen Without Prejudice Vol. 1', '1990', '8', '12 Weeks'),
('TLC', 'Waterfalls', 'CrazySexyCool', '1995', '1', '7 Weeks'),
('Led Zeppelin', 'Whole Lotta Love', 'Led Zeppelin II', '1969', '4', '15 Weeks'),
('Drake feat. Majid Jordan', 'Hold On Were Going Home', 'Nothing Was the Same', '2013', '4', '26 Weeks'),
('Martha and the Vandellas', 'Dancing in the Street', 'Dance Party', '1964', '2', '2 Weeks'),
('Ben E. King', 'Stand by Me', 'Dont Play That Song!', '1961', '4', '14 Weeks'),
('Eric B. and Rakim', 'Paid in Full', 'Paid in Full', '1987', '58', '8 Weeks'),
('Journey', 'Dont Stop Believin', 'Escape (1981)', '1981', '9', '16 Weeks'),
('Tina Turner', 'Whats Love Got to Do With It', 'Private Dancer', '1984', '1', '28 Weeks'),
('The Beatles', 'She Loves You', 'Twist and Shout', '1964', '3', '31 Weeks'),
('Otis Redding', 'Try a Little Tenderness', 'ITS ALIVE', '1966', '25', '11 Weeks'),
('Ariana Grande', 'Thank U Next', 'Thank U Next', '2019', '1', '17 Weeks'),
('Blondie', 'Heart of Glass', 'Parallel Lines', '1979', '1', '12 Weeks'),
('Madonna', 'Vogue', 'Live at the Reunion Arena Dallas 1990', '1990', '1', '24 Weeks'),
('Bob Marley and the Wailers', 'No Woman No Cry', 'Natty Dread', '1975', '38', '14 Weeks'),
('Rod Stewart', 'Maggie May', 'Every Picture Tells a Story', '1971', '1', '5 Weeks'),
('George Jones', 'He Stopped Loving Her Today', 'I Am What I Am', '1980', '1', '18 Weeks'),
('The Clash', 'London Calling', 'London Calling', '1980', '27', '15 Weeks'),
('The Rolling Stones', 'Jumpin Jack Flash', 'Child of the Moon', '1968', '4', '19 Weeks'),
('Outkast', 'Ms. Jackson', 'Sole Sunday', '2000', '1', '26 Weeks'),
('James Taylor', 'Fire and Rain', 'Sweet Baby James', '1970', '3', '12 Weeks'),
('Fats Domino', 'Blueberry Hill', 'This Is Fats Domino', '1956', '2', '11 Weeks'),
('Led Zeppelin', 'Kashmir', 'Physical Graffiti', '1975', '89', '6 Weeks'),
('Elton John', 'Rocket Man', 'Honky Château', '1972', '6', '15 Weeks'),
('Green Day', 'Basket Case', 'Dookie', '1994', '1', '5 Weeks'),
('The Shirelles', 'Will You Love Me Tomorrow', 'Tonights the Night', '1960', '44', '2 Weeks'),
('Creedence Clearwater Revival', 'Proud Mary', 'Bayou Country', '1969', '2', '3 Weeks'),
('Rick James', 'Super Freak', 'Street Songs', '1981', '16', '10 Weeks'),
('Howlin Wolf', 'Spoonful', 'The Howlin Wolf Album', '1960', '105', '2 Weeks'),
('The Strokes', 'Last Nite', 'Is This It', '2001', '14', '8 Weeks'),
('The Kingsmen', 'Louie Louie', 'The Kingsmen in Person', '1963', '2', '6 Weeks'),
('Sonic Youth', 'Teenage Riot', 'Daydream Nation', '1988', '20', '9 Weeks'),
('The Meters', 'Cissy Strut', 'THE METERS', '1969', '23', '11 Weeks'),
('The Who', 'Baba ORiley', 'Whos Next', '1971', '4', '13 Weeks'),
('R.E.M.', 'Nightswimming', 'Automatic for the People', '1992', '27', '5 Weeks'),
('Madonna', 'Into the Groove', 'Like A Virgin', '1985', '1', '4 Weeks'),
('Nick Drake', 'Pink Moon', 'Pink Moon', '1972', '3', '6 Weeks'),
('Fleetwood Mac', 'Landslide', 'Fleetwood Mac', '1975', '51', '57 Weeks'),
('Bob Dylan', 'Mr. Tambourine Man', 'Bringing It All Back Home', '1965', '1', '2 Weeks'),
('Hank Williams', 'Im So Lonesome I Could Cry', 'No Original Album: Hank Williams Sings', '1949', '4', '16 Weeks'),
('Mott the Hoople', 'All the Young Dudes', 'All the Young Dudes', '1972', '37', '11 Weeks'),
('Eminem', 'Lose Yourself', 'The 8 Mile Soundtrack', '2002', '1', '12 Weeks'),
('Dusty Springfield', 'Son of a Preacher Man', 'Dusty in Memphis', '1968', '10', '12 Weeks'),
('Tom Petty and the Heartbreakers', 'American Girl', 'Tom Petty and the Heartbreakers', '1976', '55', '3 Months'),
('The Five Satins', 'In the Still of the Night', 'Automatic for the People', '1956', '24', '7 Weeks'),
('Louis Armstrong', 'What a Wonderful World', 'Louis Armstrong and His Friends', '1967', '116', '57 Weeks'),
('Nina Simone', 'Mississippi Goddam', 'Nina Simone in Concert', '1964', '102', '3 Weeks'),
('Television', 'Marquee Moon', 'Marquee Moon', '1977', '30', '3 Weeks'),
('R.E.M.', 'Radio Free Europe', 'Murmur', '1983', '78', '5 Weeks'),
('The Flamingos', 'I Only Have Eyes for You', 'Flamingo Serenade', '1959', '11', '2 Weeks'),
('The Kinks', 'You Really Got Me', 'Kinks', '1964', '7', '2 Weeks'),
('Van Halen', 'Jump', 'Sixth Studio Album', '1983', '1', '5 Weeks'),
('Billie Eilish', 'Bad Guy', 'When We All Fall Asleep Where Do We Go?', '2019', '1', '9 Weeks'),
('Pink Floyd', 'Comfortably Numb', 'The Wall', '1979', '1', '4 Weeks'),
('Lou Reed', 'Walk on the Wild Side', 'Transformer', '1972', '16', '14 Weeks'),
('The Byrds', 'Eight Miles High', 'Fifth Dimension', '1966', '14', '8 Weeks'),
('Simon and Garfunkel', 'The Sounds of Silence', 'Wednesday Morning 3 AM', '1964', '1', '14 Weeks'),
('Stevie Wonder', 'You Are the Sunshine of My Life', 'Talking Book', '1972', '1', '14 Weeks'),
('Sinéad OConnor', 'Nothing Compares 2 U', 'I Do Not Want What I Havent Got', '1990', '1', '4 Weeks'),
('Michael Jackson', 'Beat It', 'Thriller', '1982', '1', '3 Weeks'),
('The Staple Singers', 'Ill Take You There', 'Be Altitude: Respect Yourself', '1972', '12', '15 Weeks'),
('Bob Dylan', 'Subterranean Homesick Blues', 'Bringing It All Back Home', '1965', '39', '9 Weeks'),
('Jimi Hendrix', 'Little Wing', 'Are You Experienced', '1967', '5', '106 Weeks'),
('David Bowie', 'Space Oddity', 'David Bowie: Space Oddity', '1969', '5', '13 Weeks'),
('N.W.A', 'Fuck tha Police', 'Straight Outta Compton', '1988', '97', '1 Week'),
('Bobbie Gentry', 'Ode to Billie Joe', 'Ode to Billie Joe', '1967', '1', '4 Weeks'),
('Geto Boys', 'Mind Playing Tricks on Me', 'We Cant be Stopped', '1991', '23', '20 Weeks'),
('The Rolling Stones', 'Wild Horses', 'Sticky Fingers', '1971', '1', '8 Weeks'),
('PJ Harvey', 'Rid of Me', 'Rid of Me', '1993', '3', '3 Weeks'),
('Patsy Cline', 'Crazy', 'Patsy Cline Showcase', '1961', '2', '21 Weeks'),
('James Brown', 'Get Up (I Feel Like Being A) Sex Machine', 'Sex Machine', '1970', '15', '8 Weeks'),
('Ann Peebles', 'I Cant Stand the Rain', 'I Cant Stand the Rain', '1973', '38', '7 Weeks'),
('Marvin Gaye', 'Sexual Healing', 'Midnight Love', '1982', '3', '10 Weeks'),
('Aerosmith', 'Dream On', 'Last Action Hero', '1971', '59', '20 Weeks'),
('David Bowie', 'Changes', 'Hunky Dory', '1971', '41', '1 Week')
; 

Select Count(*) AS 'Number of Songs from the 1970s' -- This is counting all the data, which is used by the select command. It is counting the data based on the where statement below.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Years Like "197%"; -- This will count all the data that has the songs in the 1970s.

Select Count(*) AS 'Number of Songs from the 1980s' -- This is counting all the data, which is used by the select command. It is counting the data based on the where statement below.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Years Like "198%"; -- This will count all the songs that will have the song created in the 1980s.

Select Count(*) AS 'Number of Songs that Peaked 2' -- This is counting all the data, which is used by the select command. It is counting the data based on the where statement below.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where wherePeak = "2"; -- This will count all the songs the artists created with a peak of 2.

Select Count(*) AS 'Number of Songs on Chart for longer than 10 weeks' -- This is counting all the data, which is used by the select command. It is counting the data based on the where statement below.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where longChart > "10 Weeks"; -- This will count all the songs that have been on chart for more than 10 weeks. 

Select *  -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where songTitle Like "%Love%"; -- This will select all the data, which will have a songtitle with the word love in it.

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Artist = "Led Zeppelin"; -- This will select all the data with the artist Led Zeppelin. 

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where wherePeak = "1" AND Years = "1983"; -- This will select and display all the data with a peak of 1 and in the year 1983. 

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Years = "1976" AND wherePeak != "1"; -- This will select and display all the data in the year 1976 with no peak of 1. 

Select Count(*) AS 'Number of Songs Michael Jackson made to top 200' -- This is counting all the data, which is used by the select command. It is counting the data based on the where statement below.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Artist = "Michael Jackson"; -- This will count all the data that has an artist who is Michael Jackson.

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Years Like "196%"; -- This will select and display all the data in the years during the 1960s.

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where songTitle Like "%Rock%"; -- This will select and display all the data with a song title with rock in it. 

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Years Like "200%"; -- This will select and display all the data in the years during the 2000.

Select Count(*) AS 'Number of Songs in the 2000s' -- This is counting all the data, which is used by the select command. It is counting the data based on the where statement below.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where Years Like "200%"; -- This will count all the data that will be in the years during the 2000s.

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where wherePeak > "2"; -- This will select and display all the data will a peak below 2. 

Select * -- This is selecting all the data from each column, which is including the primary key too.
From songData -- This is showing that the data needed will be in the table called songData, so this is the location of where the data is.
Where wherePeak = "1" AND Artist = "Elvis Presley"; -- This will select and display all the data with a peak of 1 and the artist is Elvis Presley. 

drop database songHits; -- This will delete the database called songHits, which will also delete the table inside of it called songData.









